Overview
Brought to you by YData
Dataset statistics
| Number of variables | 30 |
|---|---|
| Number of observations | 733863 |
| Missing cells | 28 |
| Missing cells (%) | < 0.1% |
| Total size in memory | 552.6 MiB |
| Average record size in memory | 789.6 B |
Variable types
| Numeric | 18 |
|---|---|
| Text | 11 |
| Boolean | 1 |
is_anomaly is highly imbalanced (88.3%) | Imbalance |
subscriber_sim_count is highly skewed (γ1 = 27.53600142) | Skewed |
pdv_avg_sims_per_customer is highly skewed (γ1 = 20.48589947) | Skewed |
reconstruction_error is highly skewed (γ1 = 28.40803767) | Skewed |
msisdn has unique values | Unique |
activation_dayofweek has 109831 (15.0%) zeros | Zeros |
same_wilaya has 68752 (9.4%) zeros | Zeros |
wilaya_code_diff has 665111 (90.6%) zeros | Zeros |
days_since_pdv_first_activation has 15549 (2.1%) zeros | Zeros |
time_phase_code has 127073 (17.3%) zeros | Zeros |
pdv_multi_sim_pct has 24230 (3.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-28 00:04:10.687247 |
|---|---|
| Analysis finished | 2025-04-28 00:04:30.075565 |
| Duration | 19.39 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
msisdn
Real number (ℝ)
Unique 
| Distinct | 733863 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 324843728.4 |
| Minimum | 300010025 |
|---|---|
| Maximum | 349740621 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 300010025 |
|---|---|
| 5-th percentile | 302588400.4 |
| Q1 | 312427645 |
| median | 324867641 |
| Q3 | 337367331 |
| 95-th percentile | 347287608.9 |
| Maximum | 349740621 |
| Range | 49730596 |
| Interquartile range (IQR) | 24939686 |
Descriptive statistics
| Standard deviation | 14373082.22 |
|---|---|
| Coefficient of variation (CV) | 0.0442461435 |
| Kurtosis | -1.209513558 |
| Mean | 324843728.4 |
| Median Absolute Deviation (MAD) | 12469377 |
| Skewness | 0.007568724491 |
| Sum | 2.38390793 × 1014 |
| Variance | 2.065854926 × 1014 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 349740621 | 1 | < 0.1% |
| 300010025 | 1 | < 0.1% |
| 300010038 | 1 | < 0.1% |
| 300010052 | 1 | < 0.1% |
| 300010075 | 1 | < 0.1% |
| 300010082 | 1 | < 0.1% |
| 300010113 | 1 | < 0.1% |
| 349740378 | 1 | < 0.1% |
| 349740372 | 1 | < 0.1% |
| 349740371 | 1 | < 0.1% |
| Other values (733853) | 733853 |
| Value | Count | Frequency (%) |
| 300010025 | 1 | |
| 300010038 | 1 | |
| 300010052 | 1 | |
| 300010075 | 1 | |
| 300010082 | 1 |
| Value | Count | Frequency (%) |
| 349740621 | 1 | |
| 349740612 | 1 | |
| 349740608 | 1 | |
| 349740602 | 1 | |
| 349740574 | 1 |
activation_date
Text
| Distinct | 666321 |
|---|---|
| Distinct (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 47.6 MiB |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Unique
| Unique | 604980 ? |
|---|---|
| Unique (%) | 82.4% |
Sample
| 1st row | 2025-01-29 10:56:38 |
|---|---|
| 2nd row | 2025-03-06 11:18:09 |
| 3rd row | 2025-03-14 22:48:23 |
| 4th row | 2025-02-22 11:54:44 |
| 5th row | 2025-02-02 14:36:33 |
| Value | Count | Frequency (%) |
| 2025-02-27 | 14715 | 1.0% |
| 2025-01-30 | 14006 | 1.0% |
| 2025-02-28 | 12739 | 0.9% |
| 2025-03-30 | 12693 | 0.9% |
| 2025-02-20 | 12313 | 0.8% |
| 2025-03-29 | 12229 | 0.8% |
| 2025-01-29 | 11965 | 0.8% |
| 2025-02-26 | 11711 | 0.8% |
| 2025-04-05 | 10669 | 0.7% |
| 2025-02-16 | 10425 | 0.7% |
| Other values (62929) | 1344261 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 2663710 | |
| 0 | 2273812 | |
| 1 | 1540589 | |
| - | 1467726 | |
| : | 1467726 | |
| 5 | 1262125 | |
| 3 | 792468 | 5.7% |
| 733863 | 5.3% | |
| 4 | 560640 | 4.0% |
| 7 | 304087 | 2.2% |
| Other values (3) | 876651 | 6.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 13943397 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 2663710 | |
| 0 | 2273812 | |
| 1 | 1540589 | |
| - | 1467726 | |
| : | 1467726 | |
| 5 | 1262125 | |
| 3 | 792468 | 5.7% |
| 733863 | 5.3% | |
| 4 | 560640 | 4.0% |
| 7 | 304087 | 2.2% |
| Other values (3) | 876651 | 6.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 13943397 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 2663710 | |
| 0 | 2273812 | |
| 1 | 1540589 | |
| - | 1467726 | |
| : | 1467726 | |
| 5 | 1262125 | |
| 3 | 792468 | 5.7% |
| 733863 | 5.3% | |
| 4 | 560640 | 4.0% |
| 7 | 304087 | 2.2% |
| Other values (3) | 876651 | 6.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 13943397 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 2663710 | |
| 0 | 2273812 | |
| 1 | 1540589 | |
| - | 1467726 | |
| : | 1467726 | |
| 5 | 1262125 | |
| 3 | 792468 | 5.7% |
| 733863 | 5.3% | |
| 4 | 560640 | 4.0% |
| 7 | 304087 | 2.2% |
| Other values (3) | 876651 | 6.3% |
| Distinct | 108 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.0 MiB |
Length
| Max length | 19 |
|---|---|
| Median length | 18 |
| Mean length | 6.745381631 |
| Min length | 1 |
Unique
| Unique | 29 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ALGER |
|---|---|
| 2nd row | OULED-DJELLAL |
| 3rd row | CONSTANTINE |
| 4th row | OUARGLA |
| 5th row | BORDJ-BOU-ARRERIDJ |
| Value | Count | Frequency (%) |
| alger | 144198 | |
| constantine | 52621 | 7.1% |
| setif | 52303 | 7.0% |
| oran | 35823 | 4.8% |
| chlef | 34079 | 4.6% |
| blida | 32901 | 4.4% |
| msila | 30845 | 4.1% |
| djelfa | 30188 | 4.1% |
| boumerdes | 26949 | 3.6% |
| medea | 20921 | 2.8% |
| Other values (102) | 282960 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 701683 | |
| E | 628949 | |
| L | 420535 | 8.5% |
| I | 356128 | 7.2% |
| R | 325070 | 6.6% |
| N | 289129 | 5.8% |
| T | 260154 | 5.3% |
| S | 245806 | 5.0% |
| O | 233486 | 4.7% |
| D | 211222 | 4.3% |
| Other values (39) | 1278024 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4950186 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 701683 | |
| E | 628949 | |
| L | 420535 | 8.5% |
| I | 356128 | 7.2% |
| R | 325070 | 6.6% |
| N | 289129 | 5.8% |
| T | 260154 | 5.3% |
| S | 245806 | 5.0% |
| O | 233486 | 4.7% |
| D | 211222 | 4.3% |
| Other values (39) | 1278024 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4950186 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 701683 | |
| E | 628949 | |
| L | 420535 | 8.5% |
| I | 356128 | 7.2% |
| R | 325070 | 6.6% |
| N | 289129 | 5.8% |
| T | 260154 | 5.3% |
| S | 245806 | 5.0% |
| O | 233486 | 4.7% |
| D | 211222 | 4.3% |
| Other values (39) | 1278024 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4950186 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 701683 | |
| E | 628949 | |
| L | 420535 | 8.5% |
| I | 356128 | 7.2% |
| R | 325070 | 6.6% |
| N | 289129 | 5.8% |
| T | 260154 | 5.3% |
| S | 245806 | 5.0% |
| O | 233486 | 4.7% |
| D | 211222 | 4.3% |
| Other values (39) | 1278024 |
| Distinct | 610804 |
|---|---|
| Distinct (%) | 83.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.4 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 18 |
| Mean length | 17.36415653 |
| Min length | 1 |
Unique
| Unique | 518154 ? |
|---|---|
| Unique (%) | 70.6% |
Sample
| 1st row | 069182991590951419 |
|---|---|
| 2nd row | 59048923899923990 |
| 3rd row | 109778991590927189 |
| 4th row | 715903991550999329 |
| 5th row | 965546992559917639 |
| Value | Count | Frequency (%) |
| 959293 | 905 | 0.1% |
| 993453 | 264 | < 0.1% |
| 5 | 144 | < 0.1% |
| 798154 | 68 | < 0.1% |
| 049316997590954889 | 50 | < 0.1% |
| 919316998299921489 | 46 | < 0.1% |
| 829302996590929029 | 44 | < 0.1% |
| sj13319 | 39 | < 0.1% |
| hd/0099/639 | 39 | < 0.1% |
| 959372992599995539 | 38 | < 0.1% |
| Other values (610896) | 732637 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 5015301 | |
| 5 | 1800804 | 14.1% |
| 0 | 1242655 | 9.8% |
| 7 | 753631 | 5.9% |
| 2 | 723438 | 5.7% |
| 8 | 692186 | 5.4% |
| 1 | 679700 | 5.3% |
| 4 | 612600 | 4.8% |
| 3 | 604036 | 4.7% |
| 6 | 585516 | 4.6% |
| Other values (58) | 33045 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12742912 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9 | 5015301 | |
| 5 | 1800804 | 14.1% |
| 0 | 1242655 | 9.8% |
| 7 | 753631 | 5.9% |
| 2 | 723438 | 5.7% |
| 8 | 692186 | 5.4% |
| 1 | 679700 | 5.3% |
| 4 | 612600 | 4.8% |
| 3 | 604036 | 4.7% |
| 6 | 585516 | 4.6% |
| Other values (58) | 33045 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12742912 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9 | 5015301 | |
| 5 | 1800804 | 14.1% |
| 0 | 1242655 | 9.8% |
| 7 | 753631 | 5.9% |
| 2 | 723438 | 5.7% |
| 8 | 692186 | 5.4% |
| 1 | 679700 | 5.3% |
| 4 | 612600 | 4.8% |
| 3 | 604036 | 4.7% |
| 6 | 585516 | 4.6% |
| Other values (58) | 33045 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12742912 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9 | 5015301 | |
| 5 | 1800804 | 14.1% |
| 0 | 1242655 | 9.8% |
| 7 | 753631 | 5.9% |
| 2 | 723438 | 5.7% |
| 8 | 692186 | 5.4% |
| 1 | 679700 | 5.3% |
| 4 | 612600 | 4.8% |
| 3 | 604036 | 4.7% |
| 6 | 585516 | 4.6% |
| Other values (58) | 33045 | 0.3% |
pdv_id
Text
| Distinct | 12689 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.0 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.69813303 |
| Min length | 1 |
Unique
| Unique | 646 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | D48 |
|---|---|
| 2nd row | P347521 |
| 3rd row | P665565 |
| 4th row | P966630 |
| 5th row | P954533 |
| Value | Count | Frequency (%) |
| p326910 | 5523 | 0.8% |
| p144920 | 4842 | 0.7% |
| p948936 | 4384 | 0.6% |
| dh7 | 3466 | 0.5% |
| p193926 | 3179 | 0.4% |
| p896969 | 3069 | 0.4% |
| p287979 | 2941 | 0.4% |
| p240569 | 2855 | 0.4% |
| p839536 | 2840 | 0.4% |
| p544533 | 2835 | 0.4% |
| Other values (12664) | 698483 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 678957 | |
| P | 673382 | |
| 9 | 636276 | |
| 6 | 491065 | |
| 3 | 486653 | |
| 2 | 444890 | |
| 4 | 305566 | |
| 8 | 298483 | |
| 7 | 278437 | |
| 0 | 275557 | |
| Other values (12) | 346246 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4915512 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5 | 678957 | |
| P | 673382 | |
| 9 | 636276 | |
| 6 | 491065 | |
| 3 | 486653 | |
| 2 | 444890 | |
| 4 | 305566 | |
| 8 | 298483 | |
| 7 | 278437 | |
| 0 | 275557 | |
| Other values (12) | 346246 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4915512 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5 | 678957 | |
| P | 673382 | |
| 9 | 636276 | |
| 6 | 491065 | |
| 3 | 486653 | |
| 2 | 444890 | |
| 4 | 305566 | |
| 8 | 298483 | |
| 7 | 278437 | |
| 0 | 275557 | |
| Other values (12) | 346246 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4915512 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5 | 678957 | |
| P | 673382 | |
| 9 | 636276 | |
| 6 | 491065 | |
| 3 | 486653 | |
| 2 | 444890 | |
| 4 | 305566 | |
| 8 | 298483 | |
| 7 | 278437 | |
| 0 | 275557 | |
| Other values (12) | 346246 |
pdv_wilaya
Text
| Distinct | 106 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.1 MiB |
Length
| Max length | 21 |
|---|---|
| Median length | 19 |
| Mean length | 9.423129385 |
| Min length | 1 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Algiers |
|---|---|
| 2nd row | 07-BISKRA |
| 3rd row | 25-CONSTANTINE |
| 4th row | 30-OUARGLA |
| 5th row | 34-BORDJ-BOU-ARRERIDJ |
| Value | Count | Frequency (%) |
| 16-alger | 134911 | |
| 19-setif | 50086 | 6.7% |
| 25-constantine | 49873 | 6.6% |
| 09-blida | 33434 | 4.5% |
| 02-chlef | 31829 | 4.2% |
| 31-oran | 31799 | 4.2% |
| 35-boumerdes | 30294 | 4.0% |
| 17-djelfa | 30082 | 4.0% |
| 28-msila | 29251 | 3.9% |
| 26-medea | 19721 | 2.6% |
| Other values (109) | 309022 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 755989 | 10.9% |
| A | 650574 | 9.4% |
| E | 570754 | 8.3% |
| L | 355952 | 5.1% |
| I | 330398 | 4.8% |
| R | 309978 | 4.5% |
| 1 | 307964 | 4.5% |
| N | 261532 | 3.8% |
| S | 242811 | 3.5% |
| T | 238895 | 3.5% |
| Other values (52) | 2890439 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6915286 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 755989 | 10.9% |
| A | 650574 | 9.4% |
| E | 570754 | 8.3% |
| L | 355952 | 5.1% |
| I | 330398 | 4.8% |
| R | 309978 | 4.5% |
| 1 | 307964 | 4.5% |
| N | 261532 | 3.8% |
| S | 242811 | 3.5% |
| T | 238895 | 3.5% |
| Other values (52) | 2890439 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6915286 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 755989 | 10.9% |
| A | 650574 | 9.4% |
| E | 570754 | 8.3% |
| L | 355952 | 5.1% |
| I | 330398 | 4.8% |
| R | 309978 | 4.5% |
| 1 | 307964 | 4.5% |
| N | 261532 | 3.8% |
| S | 242811 | 3.5% |
| T | 238895 | 3.5% |
| Other values (52) | 2890439 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6915286 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 755989 | 10.9% |
| A | 650574 | 9.4% |
| E | 570754 | 8.3% |
| L | 355952 | 5.1% |
| I | 330398 | 4.8% |
| R | 309978 | 4.5% |
| 1 | 307964 | 4.5% |
| N | 261532 | 3.8% |
| S | 242811 | 3.5% |
| T | 238895 | 3.5% |
| Other values (52) | 2890439 |
status
Text
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 38.5 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 6.06400786 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Active |
|---|---|
| 2nd row | Active |
| 3rd row | Active |
| 4th row | Active |
| 5th row | Active |
| Value | Count | Frequency (%) |
| active | 716611 | |
| suspended | 15897 | 2.2% |
| idle | 1023 | 0.1% |
| terminated | 332 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 750092 | |
| t | 716943 | |
| i | 716943 | |
| A | 716611 | |
| c | 716611 | |
| v | 716611 | |
| d | 33149 | 0.7% |
| n | 16229 | 0.4% |
| S | 15897 | 0.4% |
| u | 15897 | 0.4% |
| Other values (8) | 35168 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4450151 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 750092 | |
| t | 716943 | |
| i | 716943 | |
| A | 716611 | |
| c | 716611 | |
| v | 716611 | |
| d | 33149 | 0.7% |
| n | 16229 | 0.4% |
| S | 15897 | 0.4% |
| u | 15897 | 0.4% |
| Other values (8) | 35168 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4450151 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 750092 | |
| t | 716943 | |
| i | 716943 | |
| A | 716611 | |
| c | 716611 | |
| v | 716611 | |
| d | 33149 | 0.7% |
| n | 16229 | 0.4% |
| S | 15897 | 0.4% |
| u | 15897 | 0.4% |
| Other values (8) | 35168 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4450151 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 750092 | |
| t | 716943 | |
| i | 716943 | |
| A | 716611 | |
| c | 716611 | |
| v | 716611 | |
| d | 33149 | 0.7% |
| n | 16229 | 0.4% |
| S | 15897 | 0.4% |
| u | 15897 | 0.4% |
| Other values (8) | 35168 | 0.8% |
customer_type
Text
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.3 MiB |
Length
| Max length | 14 |
|---|---|
| Median length | 10 |
| Mean length | 9.994105167 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | INDIVIDUAL |
|---|---|
| 2nd row | INDIVIDUAL |
| 3rd row | INDIVIDUAL |
| 4th row | INDIVIDUAL |
| 5th row | INDIVIDUAL |
| Value | Count | Frequency (%) |
| individual | 731547 | |
| business | 2265 | 0.3% |
| non | 51 | < 0.1% |
| commercial | 51 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 2196957 | |
| D | 1463094 | |
| N | 733914 | 10.0% |
| U | 733812 | 10.0% |
| A | 731598 | 10.0% |
| L | 731598 | 10.0% |
| V | 731547 | 10.0% |
| S | 6795 | 0.1% |
| E | 2316 | < 0.1% |
| B | 2265 | < 0.1% |
| Other values (5) | 408 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7334304 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| I | 2196957 | |
| D | 1463094 | |
| N | 733914 | 10.0% |
| U | 733812 | 10.0% |
| A | 731598 | 10.0% |
| L | 731598 | 10.0% |
| V | 731547 | 10.0% |
| S | 6795 | 0.1% |
| E | 2316 | < 0.1% |
| B | 2265 | < 0.1% |
| Other values (5) | 408 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7334304 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| I | 2196957 | |
| D | 1463094 | |
| N | 733914 | 10.0% |
| U | 733812 | 10.0% |
| A | 731598 | 10.0% |
| L | 731598 | 10.0% |
| V | 731547 | 10.0% |
| S | 6795 | 0.1% |
| E | 2316 | < 0.1% |
| B | 2265 | < 0.1% |
| Other values (5) | 408 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7334304 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| I | 2196957 | |
| D | 1463094 | |
| N | 733914 | 10.0% |
| U | 733812 | 10.0% |
| A | 731598 | 10.0% |
| L | 731598 | 10.0% |
| V | 731547 | 10.0% |
| S | 6795 | 0.1% |
| E | 2316 | < 0.1% |
| B | 2265 | < 0.1% |
| Other values (5) | 408 | < 0.1% |
first_cdr_wilaya
Text
| Distinct | 59 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 35.5 MiB |
Length
| Max length | 19 |
|---|---|
| Median length | 1 |
| Mean length | 1.773027118 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ? |
|---|---|
| 2nd row | ? |
| 3rd row | ? |
| 4th row | ? |
| 5th row | ? |
| Value | Count | Frequency (%) |
| 634083 | ||
| alger | 25436 | 3.5% |
| setif | 7169 | 1.0% |
| constantine | 6526 | 0.9% |
| djelfa | 6021 | 0.8% |
| blida | 4293 | 0.6% |
| boumerdes | 3917 | 0.5% |
| oran | 3702 | 0.5% |
| medea | 3228 | 0.4% |
| msila | 2649 | 0.4% |
| Other values (56) | 40228 | 5.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| ? | 634083 | |
| A | 97479 | 7.5% |
| E | 87608 | 6.7% |
| L | 59458 | 4.6% |
| R | 45555 | 3.5% |
| I | 44174 | 3.4% |
| N | 35373 | 2.7% |
| T | 33594 | 2.6% |
| S | 32778 | 2.5% |
| G | 31324 | 2.4% |
| Other values (20) | 199733 | 15.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1301159 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| ? | 634083 | |
| A | 97479 | 7.5% |
| E | 87608 | 6.7% |
| L | 59458 | 4.6% |
| R | 45555 | 3.5% |
| I | 44174 | 3.4% |
| N | 35373 | 2.7% |
| T | 33594 | 2.6% |
| S | 32778 | 2.5% |
| G | 31324 | 2.4% |
| Other values (20) | 199733 | 15.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1301159 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| ? | 634083 | |
| A | 97479 | 7.5% |
| E | 87608 | 6.7% |
| L | 59458 | 4.6% |
| R | 45555 | 3.5% |
| I | 44174 | 3.4% |
| N | 35373 | 2.7% |
| T | 33594 | 2.6% |
| S | 32778 | 2.5% |
| G | 31324 | 2.4% |
| Other values (20) | 199733 | 15.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1301159 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| ? | 634083 | |
| A | 97479 | 7.5% |
| E | 87608 | 6.7% |
| L | 59458 | 4.6% |
| R | 45555 | 3.5% |
| I | 44174 | 3.4% |
| N | 35373 | 2.7% |
| T | 33594 | 2.6% |
| S | 32778 | 2.5% |
| G | 31324 | 2.4% |
| Other values (20) | 199733 | 15.4% |
| Distinct | 73 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.5 MiB |
Length
| Max length | 19 |
|---|---|
| Median length | 18 |
| Mean length | 6.790851971 |
| Min length | 1 |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Alger |
|---|---|
| 2nd row | Ouled Djellal |
| 3rd row | Constantine |
| 4th row | Ouargla |
| 5th row | Bordj Bou Arreridj |
| Value | Count | Frequency (%) |
| alger | 144199 | 17.1% |
| constantine | 52621 | 6.3% |
| sétif | 52303 | 6.2% |
| oran | 35823 | 4.3% |
| chlef | 34079 | 4.1% |
| blida | 32901 | 3.9% |
| m'sila | 30845 | 3.7% |
| djelfa | 30188 | 3.6% |
| boumerdès | 26949 | 3.2% |
| aïn | 24483 | 2.9% |
| Other values (73) | 376700 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 505065 | 10.1% |
| e | 450814 | 9.0% |
| l | 418966 | 8.4% |
| r | 315298 | 6.3% |
| i | 308878 | 6.2% |
| n | 288644 | 5.8% |
| t | 205383 | 4.1% |
| A | 196766 | 3.9% |
| g | 171109 | 3.4% |
| o | 159613 | 3.2% |
| Other values (42) | 1963019 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4983555 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 505065 | 10.1% |
| e | 450814 | 9.0% |
| l | 418966 | 8.4% |
| r | 315298 | 6.3% |
| i | 308878 | 6.2% |
| n | 288644 | 5.8% |
| t | 205383 | 4.1% |
| A | 196766 | 3.9% |
| g | 171109 | 3.4% |
| o | 159613 | 3.2% |
| Other values (42) | 1963019 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4983555 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 505065 | 10.1% |
| e | 450814 | 9.0% |
| l | 418966 | 8.4% |
| r | 315298 | 6.3% |
| i | 308878 | 6.2% |
| n | 288644 | 5.8% |
| t | 205383 | 4.1% |
| A | 196766 | 3.9% |
| g | 171109 | 3.4% |
| o | 159613 | 3.2% |
| Other values (42) | 1963019 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4983555 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 505065 | 10.1% |
| e | 450814 | 9.0% |
| l | 418966 | 8.4% |
| r | 315298 | 6.3% |
| i | 308878 | 6.2% |
| n | 288644 | 5.8% |
| t | 205383 | 4.1% |
| A | 196766 | 3.9% |
| g | 171109 | 3.4% |
| o | 159613 | 3.2% |
| Other values (42) | 1963019 |
pdv_wilaya_std
Text
| Distinct | 58 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.4 MiB |
Length
| Max length | 19 |
|---|---|
| Median length | 18 |
| Mean length | 6.671701666 |
| Min length | 4 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Alger |
|---|---|
| 2nd row | Biskra |
| 3rd row | Constantine |
| 4th row | Ouargla |
| 5th row | Bordj Bou Arreridj |
| Value | Count | Frequency (%) |
| alger | 148743 | |
| constantine | 53152 | 6.4% |
| sétif | 52240 | 6.3% |
| oran | 37792 | 4.6% |
| blida | 35641 | 4.3% |
| chlef | 32804 | 4.0% |
| djelfa | 30747 | 3.7% |
| boumerdès | 30740 | 3.7% |
| m'sila | 30197 | 3.6% |
| aïn | 23591 | 2.8% |
| Other values (60) | 352474 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 498864 | 10.2% |
| e | 434126 | 8.9% |
| l | 384269 | 7.8% |
| r | 330065 | 6.7% |
| i | 311362 | 6.4% |
| n | 288294 | 5.9% |
| t | 202345 | 4.1% |
| A | 199680 | 4.1% |
| g | 174423 | 3.6% |
| B | 164938 | 3.4% |
| Other values (37) | 1907749 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4896115 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 498864 | 10.2% |
| e | 434126 | 8.9% |
| l | 384269 | 7.8% |
| r | 330065 | 6.7% |
| i | 311362 | 6.4% |
| n | 288294 | 5.9% |
| t | 202345 | 4.1% |
| A | 199680 | 4.1% |
| g | 174423 | 3.6% |
| B | 164938 | 3.4% |
| Other values (37) | 1907749 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4896115 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 498864 | 10.2% |
| e | 434126 | 8.9% |
| l | 384269 | 7.8% |
| r | 330065 | 6.7% |
| i | 311362 | 6.4% |
| n | 288294 | 5.9% |
| t | 202345 | 4.1% |
| A | 199680 | 4.1% |
| g | 174423 | 3.6% |
| B | 164938 | 3.4% |
| Other values (37) | 1907749 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4896115 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 498864 | 10.2% |
| e | 434126 | 8.9% |
| l | 384269 | 7.8% |
| r | 330065 | 6.7% |
| i | 311362 | 6.4% |
| n | 288294 | 5.9% |
| t | 202345 | 4.1% |
| A | 199680 | 4.1% |
| g | 174423 | 3.6% |
| B | 164938 | 3.4% |
| Other values (37) | 1907749 |
subscriber_wilaya_code
Real number (ℝ)
| Distinct | 60 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.69939865 |
| Minimum | 0 |
|---|---|
| Maximum | 99 |
| Zeros | 90 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 16 |
| median | 19 |
| Q3 | 28 |
| 95-th percentile | 44 |
| Maximum | 99 |
| Range | 99 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 11.89623928 |
|---|---|
| Coefficient of variation (CV) | 0.5482289843 |
| Kurtosis | -0.0306252935 |
| Mean | 21.69939865 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.5660107938 |
| Sum | 15924082 |
| Variance | 141.5205091 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 144198 | |
| 25 | 52621 | 7.2% |
| 19 | 52303 | 7.1% |
| 31 | 35823 | 4.9% |
| 2 | 34079 | 4.6% |
| 9 | 32901 | 4.5% |
| 28 | 30845 | 4.2% |
| 17 | 30188 | 4.1% |
| 35 | 26949 | 3.7% |
| 26 | 20921 | 2.9% |
| Other values (50) | 273021 |
| Value | Count | Frequency (%) |
| 0 | 90 | < 0.1% |
| 1 | 1329 | 0.2% |
| 2 | 34079 | |
| 3 | 2670 | 0.4% |
| 4 | 8880 | 1.2% |
| Value | Count | Frequency (%) |
| 99 | 36 | < 0.1% |
| 58 | 306 | < 0.1% |
| 57 | 1526 | |
| 56 | 115 | < 0.1% |
| 55 | 1407 |
pdv_wilaya_code
Real number (ℝ)
| Distinct | 58 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.96676491 |
| Minimum | 0 |
|---|---|
| Maximum | 58 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 16 |
| median | 19 |
| Q3 | 28 |
| 95-th percentile | 44 |
| Maximum | 58 |
| Range | 58 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 11.17824321 |
|---|---|
| Coefficient of variation (CV) | 0.5331410569 |
| Kurtosis | -0.2824807568 |
| Mean | 20.96676491 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.4458844056 |
| Sum | 15386733 |
| Variance | 124.9531212 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 148743 | |
| 25 | 53152 | 7.2% |
| 19 | 52240 | 7.1% |
| 31 | 37792 | 5.1% |
| 9 | 35641 | 4.9% |
| 2 | 32804 | 4.5% |
| 17 | 30747 | 4.2% |
| 35 | 30740 | 4.2% |
| 28 | 30197 | 4.1% |
| 26 | 20565 | 2.8% |
| Other values (48) | 261242 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 1569 | 0.2% |
| 2 | 32804 | |
| 3 | 2732 | 0.4% |
| 4 | 8699 | 1.2% |
| Value | Count | Frequency (%) |
| 58 | 189 | |
| 57 | 174 | |
| 56 | 100 | |
| 54 | 148 | |
| 53 | 126 |
activation_hour
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.6471385 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 6009 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 16 |
| Q3 | 19 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.165197699 |
|---|---|
| Coefficient of variation (CV) | 0.2661954899 |
| Kurtosis | 0.5974994701 |
| Mean | 15.6471385 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.5390217014 |
| Sum | 11482856 |
| Variance | 17.34887187 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17 | 82413 | |
| 18 | 63913 | 8.7% |
| 16 | 61173 | 8.3% |
| 15 | 56332 | 7.7% |
| 11 | 52814 | 7.2% |
| 14 | 52074 | 7.1% |
| 19 | 48665 | 6.6% |
| 12 | 48062 | 6.5% |
| 21 | 47198 | 6.4% |
| 20 | 46981 | 6.4% |
| Other values (14) | 174238 |
| Value | Count | Frequency (%) |
| 0 | 6009 | |
| 1 | 1863 | 0.3% |
| 2 | 497 | 0.1% |
| 3 | 93 | < 0.1% |
| 4 | 60 | < 0.1% |
| Value | Count | Frequency (%) |
| 23 | 16554 | 2.3% |
| 22 | 34329 | |
| 21 | 47198 | |
| 20 | 46981 | |
| 19 | 48665 |
activation_dayofweek
Real number (ℝ)
Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.009771579 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 109831 |
| Zeros (%) | 15.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.017180449 |
|---|---|
| Coefficient of variation (CV) | 0.6702104783 |
| Kurtosis | -1.222791261 |
| Mean | 3.009771579 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.001162837344 |
| Sum | 2208760 |
| Variance | 4.069016965 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 124607 | |
| 6 | 119254 | |
| 0 | 109831 | |
| 3 | 109141 | |
| 1 | 100860 | |
| 2 | 94775 | |
| 5 | 75395 |
| Value | Count | Frequency (%) |
| 0 | 109831 | |
| 1 | 100860 | |
| 2 | 94775 | |
| 3 | 109141 | |
| 4 | 124607 |
| Value | Count | Frequency (%) |
| 6 | 119254 | |
| 5 | 75395 | |
| 4 | 124607 | |
| 3 | 109141 | |
| 2 | 94775 |
activation_month
Real number (ℝ)
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.195886698 |
| Minimum | 1 |
|---|---|
| Maximum | 4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 4 |
| Range | 3 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.9192218523 |
|---|---|
| Coefficient of variation (CV) | 0.418610784 |
| Kurtosis | -0.9318852824 |
| Mean | 2.195886698 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.1829677786 |
| Sum | 1611480 |
| Variance | 0.8449688137 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 250841 | |
| 3 | 230774 | |
| 1 | 197172 | |
| 4 | 55076 | 7.5% |
| Value | Count | Frequency (%) |
| 1 | 197172 | |
| 2 | 250841 | |
| 3 | 230774 | |
| 4 | 55076 | 7.5% |
| Value | Count | Frequency (%) |
| 4 | 55076 | 7.5% |
| 3 | 230774 | |
| 2 | 250841 | |
| 1 | 197172 |
activation_week
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.170488225 |
| Minimum | 2 |
|---|---|
| Maximum | 15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 5 |
| median | 8 |
| Q3 | 11 |
| 95-th percentile | 14 |
| Maximum | 15 |
| Range | 13 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.648526519 |
|---|---|
| Coefficient of variation (CV) | 0.4465493883 |
| Kurtosis | -1.137888382 |
| Mean | 8.170488225 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.04959208318 |
| Sum | 5996019 |
| Variance | 13.31174576 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 76252 | |
| 5 | 68015 | |
| 13 | 64004 | |
| 8 | 62000 | |
| 7 | 56999 | |
| 3 | 56911 | |
| 6 | 55974 | |
| 4 | 54504 | |
| 12 | 52688 | 7.2% |
| 14 | 50933 | 6.9% |
| Other values (4) | 135583 |
| Value | Count | Frequency (%) |
| 2 | 33993 | |
| 3 | 56911 | |
| 4 | 54504 | |
| 5 | 68015 | |
| 6 | 55974 |
| Value | Count | Frequency (%) |
| 15 | 8761 | 1.2% |
| 14 | 50933 | |
| 13 | 64004 | |
| 12 | 52688 | |
| 11 | 45029 |
time_phase
Text
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.8 MiB |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.920981164 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Morning |
|---|---|
| 2nd row | Morning |
| 3rd row | Evening |
| 4th row | Morning |
| 5th row | Afternoon |
| Value | Count | Frequency (%) |
| afternoon | 340539 | |
| evening | 263649 | |
| morning | 127073 | 17.3% |
| night | 2602 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 1462522 | |
| o | 808151 | |
| e | 604188 | |
| r | 467612 | 8.0% |
| i | 393324 | 6.8% |
| g | 393324 | 6.8% |
| t | 343141 | 5.9% |
| f | 340539 | 5.9% |
| A | 340539 | 5.9% |
| E | 263649 | 4.5% |
| Other values (4) | 395926 | 6.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5812915 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 1462522 | |
| o | 808151 | |
| e | 604188 | |
| r | 467612 | 8.0% |
| i | 393324 | 6.8% |
| g | 393324 | 6.8% |
| t | 343141 | 5.9% |
| f | 340539 | 5.9% |
| A | 340539 | 5.9% |
| E | 263649 | 4.5% |
| Other values (4) | 395926 | 6.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5812915 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 1462522 | |
| o | 808151 | |
| e | 604188 | |
| r | 467612 | 8.0% |
| i | 393324 | 6.8% |
| g | 393324 | 6.8% |
| t | 343141 | 5.9% |
| f | 340539 | 5.9% |
| A | 340539 | 5.9% |
| E | 263649 | 4.5% |
| Other values (4) | 395926 | 6.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5812915 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 1462522 | |
| o | 808151 | |
| e | 604188 | |
| r | 467612 | 8.0% |
| i | 393324 | 6.8% |
| g | 393324 | 6.8% |
| t | 343141 | 5.9% |
| f | 340539 | 5.9% |
| A | 340539 | 5.9% |
| E | 263649 | 4.5% |
| Other values (4) | 395926 | 6.8% |
same_wilaya
Real number (ℝ)
Zeros 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9063149389 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 68752 |
| Zeros (%) | 9.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2913902643 |
|---|---|
| Coefficient of variation (CV) | 0.3215110463 |
| Kurtosis | 5.777477142 |
| Mean | 0.9063149389 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.788810032 |
| Sum | 665111 |
| Variance | 0.08490828613 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 665111 | |
| 0 | 68752 | 9.4% |
| Value | Count | Frequency (%) |
| 0 | 68752 | 9.4% |
| 1 | 665111 |
| Value | Count | Frequency (%) |
| 1 | 665111 | |
| 0 | 68752 | 9.4% |
wilaya_code_diff
Real number (ℝ)
Zeros 
| Distinct | 64 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.816282369 |
| Minimum | 0 |
|---|---|
| Maximum | 87 |
| Zeros | 665111 |
| Zeros (%) | 90.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 15 |
| Maximum | 87 |
| Range | 87 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.091319635 |
|---|---|
| Coefficient of variation (CV) | 3.904304616 |
| Kurtosis | 21.90790621 |
| Mean | 1.816282369 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.591364429 |
| Sum | 1332877 |
| Variance | 50.28681417 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 665111 | |
| 44 | 9534 | 1.3% |
| 7 | 4890 | 0.7% |
| 19 | 4712 | 0.6% |
| 3 | 3176 | 0.4% |
| 18 | 2900 | 0.4% |
| 10 | 2748 | 0.4% |
| 2 | 2662 | 0.4% |
| 1 | 2360 | 0.3% |
| 25 | 2215 | 0.3% |
| Other values (54) | 33541 | 4.6% |
| Value | Count | Frequency (%) |
| 0 | 665111 | |
| 1 | 2360 | 0.3% |
| 2 | 2662 | 0.4% |
| 3 | 3176 | 0.4% |
| 4 | 1673 | 0.2% |
| Value | Count | Frequency (%) |
| 87 | 4 | |
| 83 | 7 | |
| 80 | 6 | |
| 78 | 8 | |
| 71 | 6 |
pdv_activation_count
Real number (ℝ)
| Distinct | 931 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1133.254459 |
| Minimum | 1 |
|---|---|
| Maximum | 10846 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 131 |
| median | 440 |
| Q3 | 1349 |
| 95-th percentile | 5350 |
| Maximum | 10846 |
| Range | 10845 |
| Interquartile range (IQR) | 1218 |
Descriptive statistics
| Standard deviation | 1796.797711 |
|---|---|
| Coefficient of variation (CV) | 1.585520089 |
| Kurtosis | 10.75911886 |
| Mean | 1133.254459 |
| Median Absolute Deviation (MAD) | 377 |
| Skewness | 3.062936257 |
| Sum | 831653517 |
| Variance | 3228482.014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10846 | 5523 | 0.8% |
| 9717 | 4842 | 0.7% |
| 8715 | 4384 | 0.6% |
| 6864 | 3466 | 0.5% |
| 6270 | 3179 | 0.4% |
| 5925 | 3069 | 0.4% |
| 5722 | 2941 | 0.4% |
| 5673 | 2855 | 0.4% |
| 5578 | 2840 | 0.4% |
| 5511 | 2835 | 0.4% |
| Other values (921) | 697929 |
| Value | Count | Frequency (%) |
| 1 | 161 | < 0.1% |
| 2 | 389 | |
| 3 | 573 | |
| 4 | 602 | |
| 5 | 758 |
| Value | Count | Frequency (%) |
| 10846 | 5523 | |
| 9717 | 4842 | |
| 8715 | 4384 | |
| 6864 | 3466 | |
| 6270 | 3179 |
days_since_pdv_first_activation
Real number (ℝ)
Zeros 
| Distinct | 90 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42.20767636 |
| Minimum | 0 |
|---|---|
| Maximum | 89 |
| Zeros | 15549 |
| Zeros (%) | 2.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 20 |
| median | 41 |
| Q3 | 64 |
| 95-th percentile | 84 |
| Maximum | 89 |
| Range | 89 |
| Interquartile range (IQR) | 44 |
Descriptive statistics
| Standard deviation | 25.66268689 |
|---|---|
| Coefficient of variation (CV) | 0.6080099429 |
| Kurtosis | -1.141257205 |
| Mean | 42.20767636 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.1104147927 |
| Sum | 30974652 |
| Variance | 658.5734987 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 15549 | 2.1% |
| 22 | 12280 | 1.7% |
| 50 | 12128 | 1.7% |
| 21 | 11796 | 1.6% |
| 49 | 11218 | 1.5% |
| 51 | 11059 | 1.5% |
| 80 | 10264 | 1.4% |
| 81 | 10166 | 1.4% |
| 48 | 10089 | 1.4% |
| 43 | 10066 | 1.4% |
| Other values (80) | 619248 |
| Value | Count | Frequency (%) |
| 0 | 15549 | |
| 1 | 7890 | |
| 2 | 6295 | |
| 3 | 8521 | |
| 4 | 8300 |
| Value | Count | Frequency (%) |
| 89 | 4932 | |
| 88 | 7058 | |
| 87 | 8462 | |
| 86 | 5966 | |
| 85 | 6978 |
time_phase_code
Real number (ℝ)
Zeros 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.193196823 |
| Minimum | 0 |
|---|---|
| Maximum | 3 |
| Zeros | 127073 |
| Zeros (%) | 17.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 3 |
| Range | 3 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7136360006 |
|---|---|
| Coefficient of variation (CV) | 0.5980874127 |
| Kurtosis | -0.9116410557 |
| Mean | 1.193196823 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.2418905358 |
| Sum | 875643 |
| Variance | 0.5092763414 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 340539 | |
| 2 | 263649 | |
| 0 | 127073 | 17.3% |
| 3 | 2602 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 127073 | 17.3% |
| 1 | 340539 | |
| 2 | 263649 | |
| 3 | 2602 | 0.4% |
| Value | Count | Frequency (%) |
| 3 | 2602 | 0.4% |
| 2 | 263649 | |
| 1 | 340539 | |
| 0 | 127073 | 17.3% |
subscriber_sim_count
Real number (ℝ)
Skewed 
| Distinct | 57 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.291136084 |
| Minimum | 1 |
|---|---|
| Maximum | 1745 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 1745 |
| Range | 1744 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 61.95629085 |
|---|---|
| Coefficient of variation (CV) | 14.43820229 |
| Kurtosis | 766.9002614 |
| Mean | 4.291136084 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 27.53600142 |
| Sum | 3149106 |
| Variance | 3838.581975 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 414755 | |
| 2 | 145786 | 19.9% |
| 3 | 98912 | 13.5% |
| 4 | 37272 | 5.1% |
| 5 | 18327 | 2.5% |
| 6 | 8843 | 1.2% |
| 7 | 3235 | 0.4% |
| 8 | 1504 | 0.2% |
| 1745 | 905 | 0.1% |
| 9 | 725 | 0.1% |
| Other values (47) | 3599 | 0.5% |
| Value | Count | Frequency (%) |
| 1 | 414755 | |
| 2 | 145786 | 19.9% |
| 3 | 98912 | 13.5% |
| 4 | 37272 | 5.1% |
| 5 | 18327 | 2.5% |
| Value | Count | Frequency (%) |
| 1745 | 905 | |
| 500 | 264 | < 0.1% |
| 120 | 68 | < 0.1% |
| 102 | 50 | < 0.1% |
| 92 | 46 | < 0.1% |
pdv_total_activations
Real number (ℝ)
| Distinct | 931 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1133.254459 |
| Minimum | 1 |
|---|---|
| Maximum | 10846 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 131 |
| median | 440 |
| Q3 | 1349 |
| 95-th percentile | 5350 |
| Maximum | 10846 |
| Range | 10845 |
| Interquartile range (IQR) | 1218 |
Descriptive statistics
| Standard deviation | 1796.797711 |
|---|---|
| Coefficient of variation (CV) | 1.585520089 |
| Kurtosis | 10.75911886 |
| Mean | 1133.254459 |
| Median Absolute Deviation (MAD) | 377 |
| Skewness | 3.062936257 |
| Sum | 831653517 |
| Variance | 3228482.014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10846 | 5523 | 0.8% |
| 9717 | 4842 | 0.7% |
| 8715 | 4384 | 0.6% |
| 6864 | 3466 | 0.5% |
| 6270 | 3179 | 0.4% |
| 5925 | 3069 | 0.4% |
| 5722 | 2941 | 0.4% |
| 5673 | 2855 | 0.4% |
| 5578 | 2840 | 0.4% |
| 5511 | 2835 | 0.4% |
| Other values (921) | 697929 |
| Value | Count | Frequency (%) |
| 1 | 161 | < 0.1% |
| 2 | 389 | |
| 3 | 573 | |
| 4 | 602 | |
| 5 | 758 |
| Value | Count | Frequency (%) |
| 10846 | 5523 | |
| 9717 | 4842 | |
| 8715 | 4384 | |
| 6864 | 3466 | |
| 6270 | 3179 |
pdv_unique_customers
Real number (ℝ)
| Distinct | 821 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 840.2472355 |
| Minimum | 1 |
|---|---|
| Maximum | 6726 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 27 |
| Q1 | 112 |
| median | 354 |
| Q3 | 1097 |
| 95-th percentile | 3428 |
| Maximum | 6726 |
| Range | 6725 |
| Interquartile range (IQR) | 985 |
Descriptive statistics
| Standard deviation | 1236.895147 |
|---|---|
| Coefficient of variation (CV) | 1.472060953 |
| Kurtosis | 8.475910123 |
| Mean | 840.2472355 |
| Median Absolute Deviation (MAD) | 295 |
| Skewness | 2.76374274 |
| Sum | 616626357 |
| Variance | 1529909.604 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6726 | 5523 | 0.8% |
| 6339 | 4842 | 0.7% |
| 6199 | 4384 | 0.6% |
| 5938 | 3466 | 0.5% |
| 3860 | 3179 | 0.4% |
| 3842 | 3069 | 0.4% |
| 4343 | 2941 | 0.4% |
| 4533 | 2855 | 0.4% |
| 3894 | 2840 | 0.4% |
| 3428 | 2835 | 0.4% |
| Other values (811) | 697929 |
| Value | Count | Frequency (%) |
| 1 | 233 | < 0.1% |
| 2 | 430 | |
| 3 | 644 | |
| 4 | 675 | |
| 5 | 859 |
| Value | Count | Frequency (%) |
| 6726 | 5523 | |
| 6339 | 4842 | |
| 6199 | 4384 | |
| 5938 | 3466 | |
| 4533 | 2855 |
pdv_avg_sims_per_customer
Real number (ℝ)
Skewed 
| Distinct | 2634 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.299711143 |
| Minimum | 1 |
|---|---|
| Maximum | 29.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.025672372 |
| Q1 | 1.091370558 |
| median | 1.192307692 |
| Q3 | 1.328358209 |
| 95-th percentile | 1.60764294 |
| Maximum | 29.6 |
| Range | 28.6 |
| Interquartile range (IQR) | 0.2369876506 |
Descriptive statistics
| Standard deviation | 1.288224596 |
|---|---|
| Coefficient of variation (CV) | 0.9911622309 |
| Kurtosis | 438.9347381 |
| Mean | 1.299711143 |
| Median Absolute Deviation (MAD) | 0.114959626 |
| Skewness | 20.48589947 |
| Sum | 953809.9186 |
| Variance | 1.65952261 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 24230 | 3.3% |
| 1.61254832 | 5523 | 0.8% |
| 1.532891623 | 4842 | 0.7% |
| 1.405871915 | 4384 | 0.6% |
| 1.155944763 | 3466 | 0.5% |
| 1.624352332 | 3179 | 0.4% |
| 1.542165539 | 3069 | 0.4% |
| 1.25 | 2958 | 0.4% |
| 1.31752245 | 2941 | 0.4% |
| 1.25148908 | 2855 | 0.4% |
| Other values (2624) | 676416 |
| Value | Count | Frequency (%) |
| 1 | 24230 | |
| 1.006896552 | 75 | < 0.1% |
| 1.007751938 | 58 | < 0.1% |
| 1.008196721 | 56 | < 0.1% |
| 1.00862069 | 56 | < 0.1% |
| Value | Count | Frequency (%) |
| 29.6 | 1370 | |
| 16.16666667 | 158 | < 0.1% |
| 15.4 | 32 | < 0.1% |
| 14.72222222 | 139 | < 0.1% |
| 8.516129032 | 262 | < 0.1% |
pdv_multi_sim_pct
Real number (ℝ)
Zeros 
| Distinct | 2314 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.23109174 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 24230 |
| Zeros (%) | 3.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.43902439 |
| Q1 | 7.407407407 |
| median | 14.72184532 |
| Q3 | 23.18181818 |
| 95-th percentile | 35.26803708 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 15.77441077 |
Descriptive statistics
| Standard deviation | 10.94128893 |
|---|---|
| Coefficient of variation (CV) | 0.6740944541 |
| Kurtosis | 2.73558275 |
| Mean | 16.23109174 |
| Median Absolute Deviation (MAD) | 7.809749151 |
| Skewness | 1.101034708 |
| Sum | 11911397.68 |
| Variance | 119.7118034 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 24230 | 3.3% |
| 36.60422242 | 5523 | 0.8% |
| 33.12825367 | 4842 | 0.7% |
| 29.26278432 | 4384 | 0.6% |
| 12.86628494 | 3466 | 0.5% |
| 10 | 3267 | 0.4% |
| 36.16580311 | 3179 | 0.4% |
| 34.64341489 | 3069 | 0.4% |
| 23.07160949 | 2941 | 0.4% |
| 19.19258769 | 2855 | 0.4% |
| Other values (2304) | 676107 |
| Value | Count | Frequency (%) |
| 0 | 24230 | |
| 0.6896551724 | 75 | < 0.1% |
| 0.7751937984 | 58 | < 0.1% |
| 0.8196721311 | 56 | < 0.1% |
| 0.8474576271 | 59 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 95 | < 0.1% |
| 91.66666667 | 13 | < 0.1% |
| 80 | 32 | < 0.1% |
| 77.77777778 | 297 | |
| 76.69565217 | 734 |
reconstruction_error
Real number (ℝ)
Skewed 
| Distinct | 424372 |
|---|---|
| Distinct (%) | 57.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.803216174 |
| Minimum | 0.0001709916412 |
|---|---|
| Maximum | 5744.21179 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 MiB |
Quantile statistics
| Minimum | 0.0001709916412 |
|---|---|
| 5-th percentile | 0.003809096105 |
| Q1 | 0.00916532779 |
| median | 0.01625324746 |
| Q3 | 0.02771710227 |
| 95-th percentile | 0.07940948116 |
| Maximum | 5744.21179 |
| Range | 5744.211619 |
| Interquartile range (IQR) | 0.01855177448 |
Descriptive statistics
| Standard deviation | 189.7961793 |
|---|---|
| Coefficient of variation (CV) | 27.89800801 |
| Kurtosis | 806.0726272 |
| Mean | 6.803216174 |
| Median Absolute Deviation (MAD) | 0.008328934938 |
| Skewness | 28.40803767 |
| Sum | 4992628.631 |
| Variance | 36022.58968 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5365.131941 | 266 | < 0.1% |
| 5358.788618 | 139 | < 0.1% |
| 296.6560894 | 105 | < 0.1% |
| 5358.612766 | 99 | < 0.1% |
| 5362.388097 | 87 | < 0.1% |
| 5361.305609 | 62 | < 0.1% |
| 295.9920249 | 61 | < 0.1% |
| 5364.834484 | 59 | < 0.1% |
| 5703.806651 | 53 | < 0.1% |
| 5744.21179 | 53 | < 0.1% |
| Other values (424362) | 732879 |
| Value | Count | Frequency (%) |
| 0.0001709916412 | 1 | < 0.1% |
| 0.0002323129427 | 1 | < 0.1% |
| 0.0002436047305 | 2 | |
| 0.0002756425174 | 1 | < 0.1% |
| 0.0002999267554 | 3 |
| Value | Count | Frequency (%) |
| 5744.21179 | 53 | < 0.1% |
| 5703.806651 | 53 | < 0.1% |
| 5365.131941 | 266 | |
| 5364.834484 | 59 | < 0.1% |
| 5362.814672 | 27 | < 0.1% |
is_anomaly
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 716.8 KiB |
| False | |
|---|---|
| True | 11601 |
| Value | Count | Frequency (%) |
| False | 722262 | |
| True | 11601 | 1.6% |
Sample
| msisdn | activation_date | subscriber_wilaya | subscriber_id_number | pdv_id | pdv_wilaya | status | customer_type | first_cdr_wilaya | subscriber_wilaya_std | pdv_wilaya_std | subscriber_wilaya_code | pdv_wilaya_code | activation_hour | activation_dayofweek | activation_month | activation_week | time_phase | same_wilaya | wilaya_code_diff | pdv_activation_count | days_since_pdv_first_activation | time_phase_code | subscriber_sim_count | pdv_total_activations | pdv_unique_customers | pdv_avg_sims_per_customer | pdv_multi_sim_pct | reconstruction_error | is_anomaly | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 300010025 | 2025-01-29 10:56:38 | ALGER | 069182991590951419 | D48 | Algiers | Active | INDIVIDUAL | ? | Alger | Alger | 16.0 | 16 | 10 | 3 | 1 | 5 | Morning | 1 | 0.0 | 779 | 21 | 0 | 1 | 779 | 707 | 1.101839 | 8.769448 | 0.008248 | False |
| 1 | 300010038 | 2025-03-06 11:18:09 | OULED-DJELLAL | 59048923899923990 | P347521 | 07-BISKRA | Active | INDIVIDUAL | ? | Ouled Djellal | Biskra | 51.0 | 7 | 11 | 4 | 3 | 10 | Morning | 0 | 44.0 | 2365 | 57 | 0 | 1 | 2365 | 1653 | 1.430732 | 29.280097 | 0.050278 | False |
| 2 | 300010052 | 2025-03-14 22:48:23 | CONSTANTINE | 109778991590927189 | P665565 | 25-CONSTANTINE | Active | INDIVIDUAL | ? | Constantine | Constantine | 25.0 | 25 | 22 | 5 | 3 | 11 | Evening | 1 | 0.0 | 1581 | 53 | 2 | 1 | 1581 | 1126 | 1.404085 | 28.863233 | 0.018609 | False |
| 3 | 300010075 | 2025-02-22 11:54:44 | OUARGLA | 715903991550999329 | P966630 | 30-OUARGLA | Active | INDIVIDUAL | ? | Ouargla | Ouargla | 30.0 | 30 | 11 | 6 | 2 | 8 | Morning | 1 | 0.0 | 29 | 41 | 0 | 1 | 29 | 29 | 1.000000 | 0.000000 | 0.037596 | False |
| 4 | 300010082 | 2025-02-02 14:36:33 | BORDJ-BOU-ARRERIDJ | 965546992559917639 | P954533 | 34-BORDJ-BOU-ARRERIDJ | Active | INDIVIDUAL | ? | Bordj Bou Arreridj | Bordj Bou Arreridj | 34.0 | 34 | 14 | 0 | 2 | 5 | Afternoon | 1 | 0.0 | 374 | 24 | 1 | 1 | 374 | 313 | 1.194888 | 15.654952 | 0.011609 | False |
| msisdn | activation_date | subscriber_wilaya | subscriber_id_number | pdv_id | pdv_wilaya | status | customer_type | first_cdr_wilaya | subscriber_wilaya_std | pdv_wilaya_std | subscriber_wilaya_code | pdv_wilaya_code | activation_hour | activation_dayofweek | activation_month | activation_week | time_phase | same_wilaya | wilaya_code_diff | pdv_activation_count | days_since_pdv_first_activation | time_phase_code | subscriber_sim_count | pdv_total_activations | pdv_unique_customers | pdv_avg_sims_per_customer | pdv_multi_sim_pct | reconstruction_error | is_anomaly | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 733858 | 349740574 | 2025-01-19 17:23:39 | OUARGLA | 859385291290995259 | D28 | Ouargla | Active | INDIVIDUAL | ? | Ouargla | Ouargla | 30.0 | 30 | 17 | 0 | 1 | 3 | Afternoon | 1 | 0.0 | 635 | 11 | 1 | 1 | 635 | 607 | 1.046129 | 4.283361 | 0.016321 | False |
| 733859 | 349740602 | 2025-01-20 20:09:36 | TOUGGOURT | 825591998590925279 | P669979 | 30-OUARGLA | Active | INDIVIDUAL | ? | Touggourt | Ouargla | 55.0 | 30 | 20 | 1 | 1 | 4 | Evening | 0 | 25.0 | 16 | 3 | 2 | 1 | 16 | 16 | 1.000000 | 0.000000 | 0.030959 | False |
| 733860 | 349740608 | 2025-02-17 19:09:34 | CHLEF | 089949999290995439 | P736536 | 42-TIPAZA | Active | INDIVIDUAL | TIPAZA | Chlef | Tipaza | 2.0 | 42 | 19 | 1 | 2 | 8 | Evening | 0 | 40.0 | 268 | 40 | 2 | 2 | 268 | 207 | 1.294686 | 22.222222 | 0.052666 | False |
| 733861 | 349740612 | 2025-02-25 15:09:13 | ORAN | 875559994520989549 | P173940 | 31-ORAN | Active | INDIVIDUAL | ? | Oran | Oran | 31.0 | 31 | 15 | 2 | 2 | 9 | Afternoon | 1 | 0.0 | 359 | 48 | 1 | 2 | 359 | 336 | 1.068452 | 5.952381 | 0.006285 | False |
| 733862 | 349740621 | 2025-01-08 11:45:10 | SKIKDA | 099841995590922199 | P785692 | 41-SOUK-AHRAS | Active | INDIVIDUAL | ? | Skikda | Souk Ahras | 21.0 | 41 | 11 | 3 | 1 | 2 | Morning | 0 | 20.0 | 46 | 0 | 0 | 1 | 46 | 43 | 1.069767 | 6.976744 | 0.023883 | False |